from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column,String,DateTime,Float
Student = declarative_base()

class student(Student):
    __tablename__ = "student" #表名
    #表中的各个字段设置
    SID = Column(String(10),primary_key=True,autoincrement=True)
    Sname = Column(String(10),nullable=False)
    Sex = Column(String(5),nullable=False)
    Birthday = Column(DateTime,nullable=False)
    Specialty = Column(String(20),nullable=False)
    Ascores = Column(Float,nullable=False)